package com.example.demo.dao.zl;

import com.example.demo.entity.PermissionRole;
import org.apache.ibatis.annotations.*;
import java.util.List;
@Mapper
public interface PermissionRoledao {
    @Select("select * from system_permission_role")
    public List <PermissionRole> all66();
    @Insert("insert into system_permission_role(sys_role_id,sys_permission_id)  values (#{sys_role_id,jdbcType=VARCHAR},#{sys_permission_id,jdbcType=VARCHAR})")
    public int insert9(@Param("sys_role_id") int sys_role_id, @Param("sys_permission_id") int sys_permission_id);
    @Delete("delete from system_permission_role where id=#{id}")
    public int delect9(int id);
    @Update("update system_permission_role set sys_role_id=#{sys_role_id} WHERE sys_permission_id=#{sys_permission_id}")
     public int upade9(@Param("sys_role_id") int sys_role_id,@Param("sys_permission_id") int sys_permission_id);
}
